play makAll work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All
HBAM2016AUG95
Pro 3.0
All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dullCopyright 1984-1996 Claris Corporation
and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy.
HBAM3016AUG95@
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
chart
8/7/97
CONSTANT
GRAPHICS
LABELS
LABELSINDICATOR
LOTSACRS
VBar Chart
Instructions Mac
Instructions PC
VBar ChartB
LOTSAUNDERSCORES
MAXVALUE
MINVALUE
W SCALEAUTO
SCALEMANUAL
SCALEMAX
SCALEMIN
SOLIDCHECK
] VARIABLE1
VARIABLE2
VARIABLE3
VARIABLE4
VARIABLE5
VARIABLE6
VBAR1
VBAR2
VBAR3
VBAR4
VBAR5
VBAR6
VLABEL1
VLABEL2
VLABEL3
VLABEL4
VLABEL5
VLABEL6
A Variable1B
A Variable2B
A Variable3B
A Variable4B
A Variable5B
A Variable6B
MaxValueB
VBar1B
) / (
* 123)
VBar2B
) / (
* 123)
VBar3B
) / (
* 123)
VBar4B
) / (
* 123)
VBar5B
) / (
* 123)
VBar6B
) / (
* 123)
ScaleManualB
ScaleMaxB
ScaleMinB
A ScaleAutoB
GraphicsB
VLabel1B
p = "yes"
) / (
* 123)
VLabel2B
p = "yes"
) / (
* 123)
VLabel3B
p = "yes"
) / (
* 123)
VLabel4B
p = "yes"
) / (
* 123)
VLabel5B
p = "yes"
) / (
* 123)
VLabel6B
p = "yes"
) / (
* 123)
MinValueB
LotsaCRsB
SolidCheckB
LotsaUnderscoresB
LabelsB
LabelsIndicatorB
p = "yes"
ConstantB
Instructions MacB
Instructions PCB
Vertical Bar Chart
Vertical Bar Chart
Vertical Bar Chart
Vertical Bar Chart
General:
Everything in this file is stored in a single record. No globals, relations, or scripts are used in any of the demo files, allowing all the calculations to remain stored and indexable. This gives you the greatest flexibility for incorporating it into your own solutions.
Fields:
Constant A calculation, always 1, for use as a relational key if you decide to link to this file via a relation. Set up another field of 1 in your main file, and you can set the Variable fields usin
g this relation.
Graphics This container field
s repetitions hold the graphics for the checkboxes and radio buttons.
VBar1...6 A calculated text field which forms each vertical bar. Here is the calc for VBar1:
Left(LotsaUnderscores,
If(ScaleAuto = GetRepetition(Graphics, 1),
Variable1 / MaxValue,
(Variable1 - ScaleMin) / (ScaleMax - ScaleMin))
* 123)
123 underscore characters, set on successive lines when line spacing is set to 1 pixel, will form a vertical bar that goes all
the way up to the top of the chart, so 123 is used as a multiplier for whatever percentage of the maximum each bar should be. If automatic scaling is turned on (line 2), this percentage is simply Variable1/MaxValue. Otherwise, manual scaling has been selected and the expression in line 4 computes the correct percentage. Last, the number of underscore characters determined by this percentage of 123 is extracted from the LotsaUnderscores field (line 1).
VLabel1...6 If value lab
els are set to display, this calculated text field contains the same number of 1-pixel carriage returns as the HBar fields contain bar characters, followed by a couple extra carriage returns, plus the digits of the value. If value labels are turned off it simply contains nothing.
Labels A text field containing either yes or no, which determines whether the value label fields will contain a value to be displayed at the top of each bar.
LabelsIndicator A calculated container field,
containing a checked box when Labels =
and an unchecked box when it equals
LotsaUnderscores: This is a text field containing a few hundred underscore characters, of which a certain number are taken and placed on top of each other to form each vertical bar.
LotsaCRs Ditto, except these are just a bunch of carriage returns, used to space the value labels up away from the bottom edge of the chart.
MaxValue This calculation uses the Max() aggregate function to determine
the highest variable used. The purpose of this is for the automatic scaling to be able to determine which value should stretch all the way up to the top of the chart.
ScaleAuto A container containing a checked radio button when automatic scaling is to be used.
ScaleManual A container containing a checked radio button when manual scaling is to be used.
ScaleMax The maximum value set by the user when manual scaling is selected.
ScaleMin The minimum value set by the user when manual
scaling is selected.
Variable1...6 These are the values for each bar, which you must set with your data. You can use the Set Field command, a script, a relation, or whatever you want. To use more than six bars, simply add more Number fields and name them Variable7, Variable8, etc.
Layout:
Each VBar text field must be bolded and have line spacing set to 1 pixel in the paragraph options, and the right font and size must be selected, to eliminate space between the underscore charact
ers and make them appear to be a solid bar. The text color determines the color of the bar. In this file, each VBar field was duplicated to appear three times on the layout; one with a darker text color a couple pixels lower and to the right of the frontmost field, and one with a dark gray text color a little further away. This provides the snazzy 3D plus dropshadow effect.
The VLabel field needs only to be placed right on top of the frontmost VBar field.
Resizing:
The bar gr
Zaphs are easily resized. To scale them vertically, all you need do is change the 123 constant in the VBar and VLabel fields. To scale them horizontally, just change the font size of the VBar fields. The line height will remain at 1 pixel, but it will spread horizontally according to the width of the underscore character in the new font size.
Everything in this file is stored in a single record. No globals, relations, or scripts are used in any of the demo files, allowing all the calculations to remain stored and indexable. This gives you the greatest flexibility for incorporating it into your own solutions.
Fields:
Constant A calculation, always 1, for use as a relational key if you decide to link to this file via a relation. Set up another field of 1 in your main file, and you can set the Variable fields usin
g this relation.
Graphics This container field
s repetitions hold the graphics for the checkboxes and radio buttons.
VBar1...6 A calculated text field which forms each vertical bar. Here is the calc for VBar1:
Left(LotsaUnderscores,
If(ScaleAuto = GetRepetition(Graphics, 1),
Variable1 / MaxValue,
(Variable1 - ScaleMin) / (ScaleMax - ScaleMin))
* 123)
123 underscore characters, set on successive lines when line spacing is set to 1 pixel, will form a vertical bar that goes all
the way up to the top of the chart, so 123 is used as a multiplier for whatever percentage of the maximum each bar should be. If automatic scaling is turned on (line 2), this percentage is simply Variable1/MaxValue. Otherwise, manual scaling has been selected and the expression in line 4 computes the correct percentage. Last, the number of underscore characters determined by this percentage of 123 is extracted from the LotsaUnderscores field (line 1).
VLabel1...6 If value la
bels are set to display, this calculated text field contains the same number of 1-pixel carriage returns as the HBar fields contain bar characters, followed by a couple extra carriage returns, plus the digits of the value. If value labels are turned off it simply contains nothing.
Labels A text field containing either yes or no, which determines whether the value label fields will contain a value to be displayed at the top of each bar.
LabelsIndicator: A calculated container fi
eld, containing a checked box when Labels = "yes" and an unchecked box when it equals "no."
LotsaUnderscores: This is a text field containing a few hundred underscore characters, of which a certain number are taken and placed on top of each other to form each vertical bar.
LotsaCRs Ditto, except these are just a bunch of carriage returns, used to space the value labels up away from the bottom edge of the chart.
MaxValue This calculation uses the Max() aggregate function to dete
rmine the highest variable used. The purpose of this is for the automatic scaling to be able to determine which value should stretch all the way up to the top of the chart.
ScaleAuto A container containing a checked radio button when automatic scaling is to be used.
ScaleManual A container containing a checked radio button when manual scaling is to be used.
ScaleMax The maximum value set by the user when manual scaling is selected.
ScaleMin The minimum value set by the user when m
anual scaling is selected.
Variable1...6 These are the values for each bar, which you must set with your data. You can use the Set Field command, a script, a relation, or whatever you want. To use more than six bars, simply add more Number fields and name them Variable7, Variable8, etc.
Layout:
Each VBar text field must be bolded and have line spacing set to 1 pixel in the paragraph options, and the right font and size must be selected, to eliminate space between the underscore ch
aracters and make them appear to be a solid bar. The text color determines the color of the bar. In this file, each VBar field was duplicated to appear three times on the layout; one with a darker text color a couple pixels lower and to the right of the frontmost field, and one with a dark gray text color a little further away. This provides the snazzy 3D plus dropshadow effect.
The VLabel field needs only to be placed right on top of the frontmost VBar field.
Resizing:
The ba
^r graphs are easily resized. To scale them vertically, all you need do is change the 123 constant in the VBar and VLabel fields. To scale them horizontally, just change the font size of the VBar fields. The line height will remain at 1 pixel, but it will spread horizontally according to the width of the underscore character in the new font size.
(.txt)